The following ipython notebook will demonstrate how to access and download data from the ENTSO-E Transparency Platform.
We have created this short guide following a query on twitter from @pinkpoedel and @Sustainable2050 regarding installed generation capacity in the Netherlands. @Sustainable2050 posted a nice graphic from energy-charts.de. We are going to produce something similar for the Netherlands.
The Transparency platform has been running since the beginning of 2015 as such we can only analyse data from 01.01.2015 onwards.
Head over to the transparency platform and look for the generation tab. In the drop down you should look for the Installed Capacity per Production Type link.
You will then be presented with a view similar to the one below.

You now need to scroll down the left hand menu until you see the Netherlands. Select this.
Using the menu on the top right you can select the range of years you would like to examine.

Now that we have found the data we want we can now download it in a number of formats.
We are going to download the table as a CSV file, so that we can work with it in python and pandas easily.
Now for the easy bits of code.
This notebook uses the following packages for python
# first we will setup plot.ly so we can use it offline
import plotly as py
py.offline.init_notebook_mode()
import pandas as pd
import numpy as np
# cufflinks provides some hand wrappers for jumping straight from a pandas dataframe to a plotly plot.
import cufflinks as cf
cf.go_offline() # makes sure cufflinks doesn't look for api key